
/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/wyy_app_report?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_user_activity \
--export-dir /user/spark/warehouse/wyy_music_warehouse/ads_user_activity \
--update-mode allowinsert \
--update-key 'dt,activity_day' \
--fields-terminated-by '\t' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/wyy_app_report?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_user_new_user_count \
--export-dir /user/spark/warehouse/wyy_music_warehouse/ads_user_new_user_count \
--update-mode allowinsert \
--update-key 'dt' \
--fields-terminated-by '\t' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/wyy_app_report?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_popular_song_rank \
--export-dir /user/spark/warehouse/wyy_music_warehouse/ads_popular_song_rank \
--update-mode allowinsert \
--update-key 'song_id,song_name,artist_name' \
--fields-terminated-by '\t' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/wyy_app_report?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_song_play_completion_rate \
--export-dir /user/spark/warehouse/wyy_music_warehouse/ads_song_play_completion_rate \
--update-mode allowinsert \
--update-key 'song_id,song_name' \
--fields-terminated-by '\t' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/wyy_app_report?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_province_play_count_rk \
--export-dir /user/spark/warehouse/wyy_music_warehouse/ads_province_play_count_rk \
--update-mode allowinsert \
--update-key 'province' \
--fields-terminated-by '\t' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/wyy_app_report?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_city_play_count_per \
--export-dir /user/spark/warehouse/wyy_music_warehouse/ads_city_play_count_per \
--update-mode allowinsert \
--update-key 'city' \
--fields-terminated-by '\t' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/wyy_app_report?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_os_type \
--export-dir /user/spark/warehouse/wyy_music_warehouse/ads_os_type \
--update-mode allowinsert \
--update-key 'os_type' \
--fields-terminated-by '\t' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1



/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/wyy_app_report?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_network_type \
--export-dir /user/spark/warehouse/wyy_music_warehouse/ads_network_type \
--update-mode allowinsert \
--update-key 'network_type' \
--fields-terminated-by '\t' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1
